Tabela CashPeriod

Definicja tabeli CashPeriod

Name

CashPeriod

Code

CashPeriod

Comment

okres rozliczeniowy / raport kasowy


Lista kolumn tabeli CashPeriod

Name

Code

CashPeriodID

CashPeriodID

IdentifierTypeID

IdentifierTypeID

ExternalValue

ExternalValue

OpenAmount

OpenAmount

CloseAmount

CloseAmount

StartDT

StartDT

StopDT

StopDT


Kolumna CashPeriodID tabeli CashPeriod

Definicja kolumny CashPeriodID tabeli CashPeriod

Name

CashPeriodID

Code

CashPeriodID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna IdentifierTypeID tabeli CashPeriod

Definicja kolumny IdentifierTypeID tabeli CashPeriod

Name

IdentifierTypeID

Code

IdentifierTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ExternalValue tabeli CashPeriod

Definicja kolumny ExternalValue tabeli CashPeriod

Name

ExternalValue

Code

ExternalValue

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna OpenAmount tabeli CashPeriod

Definicja kolumny OpenAmount tabeli CashPeriod

Name

OpenAmount

Code

OpenAmount

Data Type

NUMBER(19,4)

Mandatory

No

Comment

Stan otwarcia kasy


Kolumna CloseAmount tabeli CashPeriod

Definicja kolumny CloseAmount tabeli CashPeriod

Name

CloseAmount

Code

CloseAmount

Data Type

NUMBER(19,4)

Mandatory

No

Comment

Stan zamkniecia kasy


Kolumna StartDT tabeli CashPeriod

Definicja kolumny StartDT tabeli CashPeriod

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli CashPeriod

Definicja kolumny StopDT tabeli CashPeriod

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Lista kluczy tabeli CashPeriod

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli CashPeriod

Definicja klucza Identifier_1 tabeli CashPeriod

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment